Tally Request XML formats, Tally Integration with any platform

Tally Request XMLs

Tally Integration, Tally ERP 9 Integration with Node.JS

Tally ERP Data Accessing via Node.js

Getting Tally ERP data using Server side javascript (node.js)

1. Create a NodeJS, express application
2. Install necessary plugins such as cors,xml,body-parser and request.

Server.js

var express = require('express');
var router = express.Router();
var bodyParser = require('body-parser');
var cors = require('cors');
var request = require('request');
require('body-parser-xml')(bodyParser);
var xml = require('xml');
var async = require('async');
/*Tally xml query*/
var xmlstring = '<ENVELOPE>
<HEADER>
<TALLYREQUEST>Export DATA</TALLYREQUEST>
</HEADER>
<BODY>
<EXPORTDATA>
<REQUESTDESC>
<REPORTNAME>LIST of Companies</REPORTNAME>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
</STATICVARIABLES>
</REQUESTDESC>
</EXPORTDATA> </BODY>
</ENVELOPE>';
let app = express();
app.use(bodyParser.json());
/* use CORS to avoid net::ERR_CONNECTION_RESET */
app.use(cors);
app.post("/",(req,res) =>{ /*
Dynamic Tally xml Query parameter
const dbrequest = req.body.datarequest;
const params = req.body.params;
*/
var options = {
uri: 'http://localhost:9000',

method: 'POST',

headers: { 'Content-Type': 'text/xml;
charset:UTF-8',
'Content-Length': Buffer.byteLength(xmlstring)},
body: req.body.xmlstr
};
var result="";
async.parallel([
function(callback) {
/* tally data fetch from local tally server*/
var url = "http://localhost:9000";
request(options, function(err, response, body) {
// JSON body
if(err) { console.log(err);
callback(true);
return;
}

result = body;
callback(false, body);
});

}

],function(err, results) {
if(err) { console.log(err);
res.send(500,"Server Error");
return;
}
res.send("result--->"+result);
}
);
}

app.listen(4000,'localhost');

Export Optional Vouchers from Tally -XML Request

Tally Request XML for Exporting Optional Vouchers

Tally Integration with Third Party Application using PHP,ASP.NET, VB.Net,JSP

<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Collection</TYPE>
<ID>Vch Collection</ID>
</HEADER>
<BODY>
<DESC>

<STATICVARIABLES>
<SVCURRENTCOMPANY>#company</SVCURRENTCOMPANY>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
<SVFROMDATE TYPE="Date">#fromdate</SVFROMDATE>
<SVTODATE TYPE="Date">#todate</SVTODATE>

</STATICVARIABLES>

<COLLECTION NAME="Vch Collection" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TYPE>Voucher</TYPE>

<FETCH>ADDRESS.LIST,DATE,PARTYNAME,PARTYLEDGERNAME,BASICBASEPARTYNAME,NARRATION,LEDGERENTRIES.LIST,NARRATION</FETCH>

<FILTERS>TYPOFSALES</FILTERS>

</COLLECTION>

<SYSTEM TYPE="Formulae" NAME="TYPOFSALES">
($VOUCHERTYPENAME contains "Credit Note") AND ($ISOPTIONAL contains "YES")
</SYSTEM>

</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>

Tally XML Integrations

Tally Alter Credit Limit and Credit Days using XML Request

Tally Request XML for Alter Party / Customer Credit Limit and Days

Tally Integration with Third Party Application using PHP,ASP.NET, VB.Net,JSP

<ENVELOPE>
<HEADER>
<TALLYREQUEST>Import Data</TALLYREQUEST>
</HEADER>
<BODY>
<IMPORTDATA>
<REQUESTDESC>
<REPORTNAME>All Masters</REPORTNAME>
<STATICVARIABLES>
<SVCURRENTCOMPANY>#Company</SVCURRENTCOMPANY>
</STATICVARIABLES>
</REQUESTDESC>
<REQUESTDATA>
<TALLYMESSAGE xmlns:UDF="TallyUDF">

<CREDITLIMIT>#CREDITLIMIT</CREDITLIMIT>
<BILLCREDITPERIOD>#CREDITDAYS</BILLCREDITPERIOD>
</LEDGER>

</TALLYMESSAGE>
</REQUESTDATA>
</IMPORTDATA>
</BODY>
</ENVELOPE>

Tally XML Integrations

Sales Register all Sales Voucher Type

How to export All Sales data from tally using XML request

Request for all Sales voucher type details in XML Format from Tally using Collection Object.

<ENVELOPE>
<HEADER>
   <VERSION>1</VERSION>
   <TALLYREQUEST>Export</TALLYREQUEST>
   <TYPE>Collection</TYPE>
   <ID>List of All Sales Vouchers</ID>
</HEADER>
<BODY>
<DESC>

<STATICVARIABLES>
    <SVCURRENTCOMPANY>company</SVCURRENTCOMPANY>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    <SVFROMDATE TYPE="Date">#fromdate</SVFROMDATE>
<SVTODATE TYPE="Date">#todate</SVTODATE>

</STATICVARIABLES>

<COLLECTION NAME="List of All Sales Vouchers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TYPE>Voucher</TYPE>

<FETCH>ADDRESS.LIST,DATE,PARTYNAME,LEDGERENTRIES.LIST</FETCH>

</COLLECTION>

</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>